UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'czGFr0G6gr2o7w0bVl4ug41q5I/pneYTkS7WYDKU2Kw='
WHERE
key_id = 'a0d58017c3def9e49c3b67702d7b86c583eb3ed473f9d7b61bbdd8235d57e9b2'
AND (
token = 'czGFr0G6gr2o7w0bVl4ug41q5I/pneYTkS7WYDKU2Kw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)