UPDATE
q_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U+XNPbBCeVTFFMdGjpEeurdtaR5lu8fFa3Xr1Eu7QZk='
WHERE
key_id = 'b31b9e2c90fd22b228d4b47390a2d0cc7bea3b2557e6c4d66fd48c97b546b124'
AND (
token = 'U+XNPbBCeVTFFMdGjpEeurdtaR5lu8fFa3Xr1Eu7QZk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)