UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nKPv4IGVJHOu7W5fPH/KatjjYJW3gk9RXaQ6yiO5SZA='
WHERE
key_id = 'e256ec3a487877641838b5c57c4faad61cd1321cc8a27b2ee522db5857ac0971'
AND (
token = 'nKPv4IGVJHOu7W5fPH/KatjjYJW3gk9RXaQ6yiO5SZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)