UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0NLYz2Czox6fSv8GynRzy+DL77xM0QmjsJKDDhLrhew='
WHERE
key_id = 'e8e04b58c18e06e83ffff25a397e0acce52cce080d72ee56d70fde0edbfd1e7c'
AND (
token = '0NLYz2Czox6fSv8GynRzy+DL77xM0QmjsJKDDhLrhew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)