UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'yqdhMA0spYaYIH6HiJ2sxadG2IDYk3hBrp1Zo9fZ4IU=' 
WHERE 
  key_id = '3532b6cfb38d7827711f8e2528ace27b890f7e244f413e284ff7771c77e89da3' 
  AND (
    token = 'yqdhMA0spYaYIH6HiJ2sxadG2IDYk3hBrp1Zo9fZ4IU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027