UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CIX+TIuGFGt65+ouNz5rK3thZh7vc19h6ld5fAecIME='
WHERE
key_id = 'a7ea39ba9931c57fff126bdf2bb7b5c1b4b118b758a9db457ccb4ec2fb0cda71'
AND (
token = 'CIX+TIuGFGt65+ouNz5rK3thZh7vc19h6ld5fAecIME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)