UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'O3fzLPUjuE0BGbg2i9PZHKoqJT5EDUxknnf4IHMt/oA=' 
WHERE 
  key_id = 'd364501d93a4cbd080f9ecac1489e509fd1e4234aebf5decb11ef9b518b2734c' 
  AND (
    token = 'O3fzLPUjuE0BGbg2i9PZHKoqJT5EDUxknnf4IHMt/oA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029