UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zvdNtwABf8KD5wnHzMZSGlZlMwtDy/gHvlLnNJ/9/A8='
WHERE
key_id = '3dd7b2ad58056aa282701a58a4007bde86918bae306ae229a27c2c1f1b81d4fc'
AND (
token = 'zvdNtwABf8KD5wnHzMZSGlZlMwtDy/gHvlLnNJ/9/A8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)