UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qF2kyHfOLo2E9JRmggjJNO6uD8uubN4q+7Tc7nASx4g=' 
WHERE 
  key_id = 'e0d2b235dc47ae8009e402669002e8ab587a9a45d1aaf4ff252ab13e862a97b3' 
  AND (
    token = 'qF2kyHfOLo2E9JRmggjJNO6uD8uubN4q+7Tc7nASx4g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034