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