UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aRWL8u6aBUMEoUHB+f0Z3fxdcD50MFE1iJMdJsipwwY='
WHERE
key_id = 'a75d115592a26df7376b7ad2b1c21c58995286aecd9f946a6d2ce8e247085ac3'
AND (
token = 'aRWL8u6aBUMEoUHB+f0Z3fxdcD50MFE1iJMdJsipwwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)