UPDATE
q_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hfJn0W4sL5jzG/0afxsgpTHOGSfm4J6vqKKYWzOc9dw='
WHERE
key_id = 'e9efdbc6c8b628de5dfa5872010b4548867f32c6a26b50b0c0a58da05bffe54b'
AND (
token = 'hfJn0W4sL5jzG/0afxsgpTHOGSfm4J6vqKKYWzOc9dw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)