UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hFIjfM+MGnuO3geGrJv5F/6Mhl8v79QXehDhkrVnoMM=' 
WHERE 
  key_id = '204be6c8a421e999669f3d47299a3abed69b11c284f88e1e989f71cac33c4018' 
  AND (
    token = 'hFIjfM+MGnuO3geGrJv5F/6Mhl8v79QXehDhkrVnoMM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045