UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JxUJbMJTyLEdMba+PLZSxNg1Y8rcIkGmtW7/LPcVl9A='
WHERE
key_id = 'f9e09c01234ca2ffa7f89f0e0d2fdfe0b52b0c713a739898670079a22bf34324'
AND (
token = 'JxUJbMJTyLEdMba+PLZSxNg1Y8rcIkGmtW7/LPcVl9A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)