UPDATE
q_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hDmvJd6dXriwz8I7MqPaqc12lujuqWPwKE9386HWP9Q='
WHERE
key_id = 'bad2ba836ff365ecaf0e1cdb6cd8957df73f61efd25ced8872cc7539e001bafb'
AND (
token = 'hDmvJd6dXriwz8I7MqPaqc12lujuqWPwKE9386HWP9Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)