UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7N+z5wZlV6LfDSS1/becNHRJFPBWvS3wr5KIRHCk4dc='
WHERE
key_id = '28453927aeb6f9f5eacc1a66f15597b8fc55bacadf02c8c62249a2190da10d7b'
AND (
token = '7N+z5wZlV6LfDSS1/becNHRJFPBWvS3wr5KIRHCk4dc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)