UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8z7NQiEu5uSrgz1tJ9w7QaSXZ6rU9tPvesloERo8uA='
WHERE
key_id = 'b0a0b70800ea1f49d90e983d13d7d8c7825006ede0cb688d5d49b713f235270a'
AND (
token = 'N8z7NQiEu5uSrgz1tJ9w7QaSXZ6rU9tPvesloERo8uA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)