UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'VpKcw4Or2kmzozHENx07lflaZLvo70zZDlbiq4DgBr4=' 
WHERE 
  key_id = 'e1559fd304c33ba747d6512bf9fea86c531e7a9d3eb383e3825dae817e10dde5' 
  AND (
    token = 'VpKcw4Or2kmzozHENx07lflaZLvo70zZDlbiq4DgBr4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029