UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zgwxFlYaDa9o9fjZtxY1l+XOFERvHWizLnZVPujdDTA=' 
WHERE 
  key_id = 'f3b7737e1ddda26945439f0ac61f5ecf241c3f5a6d64afab600804894a62d720' 
  AND (
    token = 'zgwxFlYaDa9o9fjZtxY1l+XOFERvHWizLnZVPujdDTA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035