UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'eTpdSv93ZiEaV5ZleJm1jrhGgpgB/L+VDdAgoASfckM=' 
WHERE 
  key_id = '7beb470ae93f58c0d3b41d2d237408d0159887ce94b52881748e8fd7d3b346c3' 
  AND (
    token = 'eTpdSv93ZiEaV5ZleJm1jrhGgpgB/L+VDdAgoASfckM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032