UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'B/W2mPPJrZ8XoNhKqn4it1M4/2P29eWEAAdRz4aZ0sU=' 
WHERE 
  key_id = '833d55faf3fda72d4bf8722a41055ec08c1b3499d41077860240d9230bcb6b62' 
  AND (
    token = 'B/W2mPPJrZ8XoNhKqn4it1M4/2P29eWEAAdRz4aZ0sU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035