UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3OLIoUzjjdibfr+16GO47rbUIssUlkBvl6860YrZoc0='
WHERE
key_id = 'ccd59b3b7d0d5d62e0a7f544aa6ae694aff1141d8e098c8562e884c46a5027ba'
AND (
token = '3OLIoUzjjdibfr+16GO47rbUIssUlkBvl6860YrZoc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)