UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sUvAK+3/SoFJ10BDKzkY9UyR/CpdpZ3UmwdFs3+8Hic='
WHERE
key_id = '47ff67a5d007765b28914cf7d27d0e2d4729550c82d41d2b01e1a730c880cf12'
AND (
token = 'sUvAK+3/SoFJ10BDKzkY9UyR/CpdpZ3UmwdFs3+8Hic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)