UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Xz900ZFj5o9kEL7fPHwsNgr8751Q21nGzovWZYEUfmE=' 
WHERE 
  key_id = '8ae3cbd54eaac3bf5e08726ceb973fc938bd8f87069ae01b90fc96633a2cdffd' 
  AND (
    token = 'Xz900ZFj5o9kEL7fPHwsNgr8751Q21nGzovWZYEUfmE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041