UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XTbBipENOk5O6w9RfIdKbs/te0/TJ5uWd9s7aAkgzyM=' 
WHERE 
  key_id = 'd4672d95494c29b8c96e4eeaa15565787884f868cdbcf49dbf9d77546518f850' 
  AND (
    token = 'XTbBipENOk5O6w9RfIdKbs/te0/TJ5uWd9s7aAkgzyM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028