UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tPM6ItSBxrai+xN4nC3fGwxsBF+2+1uUMhwd+sUXmT4=' 
WHERE 
  key_id = 'b982284958bd43705d5035aee9d79387d1bb8112eab55d21b527bfba8928c84f' 
  AND (
    token = 'tPM6ItSBxrai+xN4nC3fGwxsBF+2+1uUMhwd+sUXmT4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047