UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7o5uz2ar+RazTVWH5tMixYhEdk8jrRbCtcRVob/ftfA=' 
WHERE 
  key_id = '02fb8223f31c0b1882619fa2512c15ea20993b0d01e51291eceac6d2a943ff33' 
  AND (
    token = '7o5uz2ar+RazTVWH5tMixYhEdk8jrRbCtcRVob/ftfA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028