UPDATE
q_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6zpwW8DEegxOf7bxACKW8/Jor4l3mxUYlP7b0D4tOo8='
WHERE
key_id = 'bab4a05d7aa88d61f88e36ed0ef26af2b401038c3e2728eed1aabc742a40987a'
AND (
token = '6zpwW8DEegxOf7bxACKW8/Jor4l3mxUYlP7b0D4tOo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)