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

Query time 0.00034