UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ks+FDavn8AkrasUWNe1YBd42qURQBA5r/TRSdzG5woQ=' 
WHERE 
  key_id = 'cc2e0866310ccd05996a0d41b910d3b18e2ac1a128b7b62add79c4ef0a64e051' 
  AND (
    token = 'ks+FDavn8AkrasUWNe1YBd42qURQBA5r/TRSdzG5woQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047