UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qKzXvsnO0RK8TWJJP8ArWn05IiQQnNgIw9XQPNWOubQ=' 
WHERE 
  key_id = '2494f2e60d9734f63e7f4070d80cb8927683f3e68a71f0963f2469f41c77a5a3' 
  AND (
    token = 'qKzXvsnO0RK8TWJJP8ArWn05IiQQnNgIw9XQPNWOubQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042