UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'q/BIm2WT8ws4nE9mf+id9dQuF/IKFx3mLe2issgtl88=' 
WHERE 
  key_id = '5795facc53d9ccb0bd510363c43031aa1fe5667375cd46a48b11c8d4f32ba6a6' 
  AND (
    token = 'q/BIm2WT8ws4nE9mf+id9dQuF/IKFx3mLe2issgtl88=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032