UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Mz1w7Qg1Gk1TvZGKN65IhdFvJOOm0K1PEFrZfQxjPJs=' 
WHERE 
  key_id = '35ab9fa2f3b9c9c85a2c1a865a38fbc5aa019aa8472ea7af707e176b363dda63' 
  AND (
    token = 'Mz1w7Qg1Gk1TvZGKN65IhdFvJOOm0K1PEFrZfQxjPJs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040