UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3h4MKYFMoeJ6fETc9/d2KjhHHcQqbIBFibDRaQUMBqM='
WHERE
key_id = '42487323249674d35f632d5feb807ed13f954c12ea089379178c90cd19f0b410'
AND (
token = '3h4MKYFMoeJ6fETc9/d2KjhHHcQqbIBFibDRaQUMBqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)