UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'lFOe29VIec9mC7T9F+R3qIfyeDbVJNmgT+MVdM2CprQ=' 
WHERE 
  key_id = 'a1d3b2a4556566314740dd2942a85d5ea977ce1c3845d2310b06518ae25fc419' 
  AND (
    token = 'lFOe29VIec9mC7T9F+R3qIfyeDbVJNmgT+MVdM2CprQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036