UPDATE
q_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XBcXJ/8sdhA4q0ujn7t8Noyk/NDteKbO128PZvdtCM8='
WHERE
key_id = '32da198c1e167d87b0c78b043d588ddf40acddb697f8df2df18e882db8b133c0'
AND (
token = 'XBcXJ/8sdhA4q0ujn7t8Noyk/NDteKbO128PZvdtCM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)