UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qrjk9q8lfiJkJfX9EMms06KNowS13aaSJ9AmIR4jPhY=' 
WHERE 
  key_id = 'd21c99c82ba3c1a409e342c4e9c5c9bde3e24327275244fc7675b7b94d3d7ca1' 
  AND (
    token = 'qrjk9q8lfiJkJfX9EMms06KNowS13aaSJ9AmIR4jPhY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039