UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'giKDvN7j+WbKmUlbD+drfafIKdohvz0N1BrXQZjMawk=' 
WHERE 
  key_id = '07ef4e75c9fa9368d43ee9c3635152d6838af518f1ec5da30aa8af68114bf906' 
  AND (
    token = 'giKDvN7j+WbKmUlbD+drfafIKdohvz0N1BrXQZjMawk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032