UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'q9tspqT3UInHpZfI7ppRlqwYxniU5D+9OC0+h2AUTTQ=' 
WHERE 
  key_id = 'b9a2195e26c19006a980c53ce07b7abd16c5c3092769d43b18497d210eeb50c6' 
  AND (
    token = 'q9tspqT3UInHpZfI7ppRlqwYxniU5D+9OC0+h2AUTTQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029