UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NfoCESRGhVWOBrICUnu+JiC5y6+AeUGR+QRSdhzS+oQ='
WHERE
key_id = '6dcdb49e03c0bda5aa4f3c13473ed728a0e57ebfb52bbbbe4aab57ce692b4242'
AND (
token = 'NfoCESRGhVWOBrICUnu+JiC5y6+AeUGR+QRSdhzS+oQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)